Calculate dsrs for local authorities
## # A tibble: 6 x 10
## # Groups: areaName, date [6]
## areaName date total_count total_pop value lowercl uppercl confidence
## <chr> <date> <int> <dbl> <dbl> <dbl> <dbl> <chr>
## 1 York 2020-11-19 288 210618 137. 122. 155. 95%
## 2 York 2020-11-20 276 210618 131. 116. 148. 95%
## 3 York 2020-11-21 277 210618 133. 117. 150. 95%
## 4 York 2020-11-22 265 210618 126. 111. 143. 95%
## 5 York 2020-11-23 244 210618 116. 102. 132. 95%
## 6 York 2020-11-24 224 210618 105. 91.6 120. 95%
## # … with 2 more variables: statistic <chr>, method <chr>
Get tiers
## # A tibble: 320 x 3
## local_authority_district_apr… local_authority_district_apr… local_covid_19_t…
## <chr> <chr> <chr>
## 1 E06000001 Hartlepool Tier 3
## 2 E06000002 Middlesbrough Tier 3
## 3 E06000003 Redcar and Cleveland Tier 3
## 4 E06000004 Stockton-on-Tees Tier 3
## 5 E06000005 Darlington Tier 3
## 6 E06000006 Halton Tier 2
## 7 E06000007 Warrington Tier 2
## 8 E06000008 Blackburn with Darwen Tier 3
## 9 E06000009 Blackpool Tier 3
## 10 E06000010 Kingston upon Hull, City of Tier 3
## # … with 310 more rows